USE [AnotherSuccessfulProcedure]

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[ClassesInsert]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.ClassesInsert
END


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Neil Wilson
-- Create date: 08/29/08
-- Description:	Classes Table Insert
-- =============================================
CREATE PROCEDURE ClassesInsert

           @ClassId int,
           @ClassShortName varchar(30),
           @ClassLongName varchar(50)
	

AS
BEGIN

INSERT INTO [Classes]
           ([ClassId]
           ,[ClassShortName]
           ,[ClassLongName])
     VALUES
           (@ClassId,
            @ClassShortName,
            @ClassLongName)

END
GO
